SyCampus

Logical Entity Name | SyCampus
Default Table Name | SyCampus
Physical Only | NO
Owner | dbo
Definition |
Note |

SyCampus Columns

ColumnName | Domain | Datatype | NULL | Definition
Code |  | char(8) | NO |
Descrip |  | varchar(50) | NO |
Addr1 |  | varchar(255) | YES |
Addr2 |  | varchar(35) | YES |
City |  | char(25) | YES |
State |  | char(2) | YES |
Zip |  | char(10) | YES |
Phone1 |  | varchar(16) | YES |
Phone2 |  | varchar(16) | YES |
Phone3 |  | varchar(16) | YES |
FaxNo |  | varchar(16) | YES |
email |  | varchar(50) | YES |
url |  | varchar(50) | YES |
domainname |  | varchar(50) | YES |
PellID |  | char(6) | YES |
RptRFMSPellID |  | char(6) | YES |
AttRFMSPellID |  | char(6) | YES |
DloanID |  | char(6) | YES |
PellIdBranch |  | char(2) | YES |
DefAcademicCalendar |  | char(1) | YES |
DefPaymentMethodology |  | char(1) | YES |
DefNumPaymentPeriods |  | char(1) | YES |
DefWeeksInAcademicYr |  | int | YES |
DefCredHourInAcadYr |  | int | YES |
TGNumber |  | char(7) | YES |
EDEPath |  | varchar(255) | YES |
MinTransDate |  | datetime | YES |
LastEarnDate |  | datetime | YES |
DefaultARAccount |  | nvarchar(100) | YES |
GLCompanyNumber |  | char(8) | YES |
GLSystem |  | char(8) | YES |
GLLastDateRel |  | datetime | YES |
Active |  | bit | NO |
ModFlag |  | char(1) | NO |
Userid |  | int | NO |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
ts |  | timestamp | NO |
UseClearingHouse |  | bit | NO |
ClearinghouseRptFlag |  | char(1) | YES |
ClearingHouseWDDateFlag |  | char(1) | YES |
SyCampusID |  | int | NO |
TIN |  | char(9) | YES |
TCC |  | char(5) | YES |
AllowAccounting |  | bit | NO |
AllowEnrollments |  | bit | NO |
AllowLeads |  | bit | NO |
ArAcctIndex |  | int | YES |
CancelDays |  | int | NO |
ClassScheduleComment |  | text | YES |
DurationLOA |  | int | NO |
GreatPlainsPath |  | char(256) | YES |
RetakeGpaCalc |  | tinyint | NO |
ServicerLastExtract |  | datetime | YES |
ServicerLink |  | char(1) | YES |
ServicerSchoolNumber |  | char(10) | YES |
TimeBetweenLOA |  | int | NO |
TimesAllowedLOA |  | int | NO |
GPBatchID |  | char(40) | YES |
GreatPlainsDynPath |  | char(256) | YES |
SerialNumber |  | char(6) | YES |
FirstCollegeChoice |  | char(6) | YES |
FloatingTerm |  | bit | NO |
ReportServerPath |  | varchar(500) | YES |
IncludeT4InStandard |  | bit | NO |
SyCountryID |  | int | YES |
T4AllowEdit |  | bit | NO |
T4Earn100 |  | bit | NO |
UseTitleIVCalc |  | bit | NO |
OfficialSchoolName |  | varchar(120) | YES |
AllowNDSEnrollments |  | bit | NO |
CurrencySymbol |  | char(10) | NO |
CurrencySymbolPosition |  | tinyint | NO |
DefaultActiveStatus |  | int | NO |
DefaultNDSActiveStatus |  | int | NO |
FAFSAExtractOption |  | char(1) | NO |
LabelRptName |  | char(35) | YES |
QTDefaultSaBillCodeID |  | int | YES |
QTImportReview |  | bit | YES |
QuickTouchDSN |  | varchar(128) | YES |
UseLabelRpt |  | bit | YES |
StatusChangeDays |  | int | NO |
ServicerSchoolCode |  | char(8) | YES |
ServicerUserID |  | int | YES |
servicerpreventT4 |  | bit | YES |
FAPackStatusPromoID |  | int | YES |
ServicerExportPath |  | varchar(255) | YES |
ServicerFASyStaffID |  | int | YES |
ServicerReqTerm |  | bit | NO |
ServicerSASyStaffID |  | int | YES |
SetTermStart |  | bit | NO |
FAAdminSyStaffID |  | int | YES |
AllowMakeUpHours |  | bit | NO |
OnlinePaymentAllow |  | bit | YES |
SyPaymentAccountID |  | int | YES |
OnlinePaymentUserID |  | int | YES |
TransMoveDateBilled |  | char(1) | NO |
TransMoveStartDate |  | char(1) | NO |
TransMoveLDA |  | char(1) | NO |
TransMoveCourses |  | char(1) | NO |
TransPerformDocReview |  | char(1) | NO |
TransModifyFees |  | char(1) | NO |
TransFaCmTemplateID |  | int | YES |
TransFaStaffDef |  | char(1) | NO |
TransFaSyStaffID |  | int | YES |
TransSaCmTemplateID |  | int | YES |
TransSaSyStaffID |  | int | YES |
TransSaStaffDef |  | char(1) | NO |
TransAllowQueue |  | bit | NO |
TransQueueProcessDate |  | char(1) | NO |
SetReentryToActive |  | bit | NO |
RegSumStuAddress |  | bit | YES |
RegSumIDToPrint |  | char(1) | YES |
RegSumStudentBal |  | bit | YES |
RegSumEnrollInfo |  | bit | YES |
RegSumPrintSched |  | bit | YES |
RegSumPrintDueDate |  | bit | YES |
RegSumDueDate |  | datetime | YES |
RegSumAddDrop |  | bit | YES |
RegSumExpFunding |  | char(1) | YES |
RegSumExpFundingTerm |  | int | YES |
RegSumEstimated |  | bit | YES |
RegSumPending |  | bit | YES |
RegSumApproved |  | bit | YES |
RegSumRegComment |  | varchar(500) | YES |
RegSumStuComment |  | varchar(500) | YES |
T4CreditBalanceDocID |  | int | YES |
RegBillEnrollCampus |  | bit | NO |
EnableNIStudent |  | bit | NO |
EnableSEVIS |  | bit | NO |
DefaultStudentGroupDays |  | numeric(3, 0) | YES |
AutoDisbApprov |  | bit | NO |
AutoRefundApprov |  | bit | NO |
AutoRefundDaysToDueDate |  | int | NO |
MoveEstimates |  | bit | NO |
MoveFA |  | char(1) | NO |
MoveBudget |  | char(1) | NO |
RptEntityID |  | char(8) | YES |
ATTEntityID |  | char(8) | YES |
AddDrop |  | char(1) | NO |
AddDropDays |  | smallint | NO |
AutomateRefund |  | bit | NO |
CreditCardDataRequired |  | bit | NO |
ISIRImportMatchMethod |  | char(1) | NO |
ISIRCGroupID |  | int | YES |
ISIRVerGroupID |  | int | YES |
T4Refund30DayExemptOverride |  | bit | NO |
ImageNowPath |  | varchar(255) | YES |
DownloadableDocumentsPath |  | varchar(1000) | YES |
SaGLExportFileDefinitionID |  | int | YES |
SAGLExportFilePath |  | varchar(255) | YES |
AutoGradeLevelPromotion |  | bit | NO |
VerifyInternalCreditCards |  | bit | NO |
SyQuickLeadTemplateID |  | int | YES |
AttendancePolicy |  | varchar(1000) | YES |
AllowWaitListing |  | bit | NO |
WaitListNotificationMode |  | char(16) | NO |
MaxWaitlistTermCredits |  | int | NO |
WaitlistMaxNumOfSeats |  | int | NO |
WaitlistMaxNumOfSeatsType |  | char(16) | NO |
PriorityResolution |  | char(16) | NO |
WaitListExpirationDays |  | int | NO |
WaitListExpirationType |  | char(16) | NO |
ReservationNotificationHours |  | int | NO |
AllowReservations |  | bit | NO |
MaxReservationTermCredits |  | int | NO |
ReservationExpMins |  | int | NO |
ReservationOnlineRegConfirmMins |  | int | NO |
AllowOnlineRegistration |  | bit | NO |
WaitlistNotifStudClearCmTemplateId |  | int | YES |
WaitlistNotifStudOfferedCmTemplateId |  | int | YES |
WaitlistNotifStudAcceptedCmTemplateId |  | int | YES |
C2KEmailClient |  | bit | NO |
ReqGrade4DropCourse |  | bit | NO |
FFELID |  | char(6) | YES |
FFELIDBranch |  | char(2) | YES |
ImageNowDBConnectString |  | varchar(255) | YES |
CnReportRandomKey |  | varchar(258) | YES |
OverrideNotReq4Status |  | int | NO |
AutoDisbPost |  | bit | NO |
UseCashiering |  | bit | NO |
LimitPackageToCOA |  | bit | NO |
PreventFundsWhenNoISIR |  | bit | NO |
PreventFundsWhenZeroCOA |  | bit | NO |
DLRptEntityID |  | char(8) | YES |
DLAttEntityID |  | char(8) | YES |
CashieringTimeout |  | int | YES |
DupCriteriaStatus |  | varchar(128) | YES |
DupSyCampusGrpID |  | int | YES |
DupCmTemplateID |  | int | YES |
SyDupCriteriaID |  | int | YES |
DupAutoProcess |  | bit | NO |
UsePortal |  | bit | NO |
EvaluateAnticipatedGradeLevelPromotion |  | bit | NO |
GradeLevelPromotionCmTemplateID |  | int | YES |
T4CreditBalanceDocIDParent |  | int | YES |
T4InstChargesDocIDParent |  | int | YES |
T4InstChargesDocIDStudent |  | int | YES |
CampusLinkAmbassadorUse |  | bit | NO |
CampusLinkAmbassadorStudentSpendingLimit |  | decimal(9, 2) | NO |
RegSumLedgerCard |  | bit | YES |
UpdateLDAwithMakeUpDate |  | bit | NO |
DefaultEmployerGroupDays |  | numeric(3, 0) | YES |
FaRestrictReadytoSend |  | bit | NO |
SaRefundPolicyID |  | int | YES |
GlobalExceptionSecurity |  | bit | NO |
CrmIntegrated |  | bit | NO |
FaPackStatusPromoTolerance |  | money | YES |
RetainLDA |  | bit | NO |
AwardWithREFC |  | bit | NO |
AllowDisbBatchPostWithException |  | bit | NO |
OrigCertEstAward |  | bit | NO |
AllowDisbursementWithInSameMonth |  | bit | NO |
AllowChangeForCanceledDisbursements |  | bit | NO |
AddDropCalendarDays |  | bit | NO |
CrmStudentEntryOverride |  | bit | NO |
CrmSuppressFlag |  | bit | NO |
regsumSubsidiary |  | bit | YES |
ApplyPaymentsMethod |  | char(1) | NO |
PPChargesDocIDStudent |  | int | YES |
PPChargesDocIDParent |  | int | YES |
OPEID |  | varchar(8) | YES |
GreatPlainsDynPathIV |  | varchar(100) | YES |
GreatPlainsPathIV |  | varchar(100) | YES |
TSMStudentGroupID |  | int | YES |
TSMHoldGroupID |  | int | YES |
AllowTransactionDueDate |  | bit | NO |
AllowCreditSourceOrder |  | bit | NO |
AllowApplyCreditAudit |  | bit | NO |
AllowAcademicYearLoanPackaging |  | bit | NO |
ApplyCreditEffectiveDate |  | datetime | NO |
ACHOnlinePaymentAllow |  | bit | NO |
VerifyInternalACH |  | bit | NO |
SaACHPaymentAccountID |  | int | YES |
OnlinePaymentACHUserID |  | int | YES |
WaitlistNotificationStudentMovedToFutureReserveCmTemplateId |  | int | YES |
CancelClassSectionNotificationToStaffCmTemplateId |  | int | YES |
CancelClassSectionNotificationToStudentCmTemplateId |  | int | YES |
PortalOnlineRegistrationPayNow |  | int | NO |
PortalOnlineRegPayNowURL |  | nvarchar(500) | YES |
PortalFinancePayNow |  | int | NO |
PortalFinancePayNowURL |  | nvarchar(500) | YES |
StudentTranscriptHoldOverride |  | bit | NO |
StaffTranscriptHoldOverride |  | bit | NO |
PortalCurrentBalanceFlag |  | bit | NO |
GPHybridConnectionString |  | nvarchar(max) | YES |
FAACampusEffectiveDate |  | datetime | YES |
AllowAutoReapplyCredits |  | bit | NO |
FwsReportingEntityId |  | nvarchar(8) | YES |
FwsAttendingId |  | nvarchar(8) | YES |
UpdateLastEarnedDate |  | bit | NO |

SyCampus Primary and Unique Keys

Key Name | Key Type | Keys
SyCampus_SyCampusId_Code_U_N_IDX | Index | SyCampusID, Code
SyCampus_SyCampusID_U_C_IDX | PrimaryKey | SyCampusID

SyCampus Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
SyGroups | Non-Identifying | Zero or One to Zero or More | FK_SyCampus_ISIRCGroupID_SyGroups_SyGroupsID |  |  | ISIRCGroupID | NO | YES
SyGroups | Non-Identifying | Zero or One to Zero or More | FK_SyCampus_ISIRVerGroupID_SyGroups_SyGroupsID |  |  | ISIRVerGroupID | NO | YES
SyStaff | Non-Identifying | Zero or One to Zero or More | FK_SyCampus_OnlinePaymentUserID_SyStaff_SyStaffID |  |  | OnlinePaymentUserID | NO | YES
SaACHPaymentAccount | Non-Identifying | Zero or One to Zero or More | FK_SyCampus_SaACHPaymentAccountId_SaACHPaymentAccount_SaACHPaymentAccountId |  |  | SaACHPaymentAccountID | NO | YES
SaGlExportFileDefinition | Non-Identifying | Zero or One to Zero or More | FK_SyCampus_SaGLExportFileDefinitionID_SaGLExportFileDefinition_SaGLExportFileDefinitionID |  |  | SaGLExportFileDefinitionID | NO | YES
SaRefundPolicy | Non-Identifying | Zero or One to Zero or More | FK_SyCampus_SaRefundPolicyID_SaRefundPolicy_SaRefundPolicyID |  |  | SaRefundPolicyID | NO | YES
SyPaymentAccount | Non-Identifying | Zero or One to Zero or More | FK_SyCampus_SyPaymentAccountID_SyPaymentAccount_SyPaymentAccountID |  |  | SyPaymentAccountID | NO | YES
SyQuickLeadTemplate | Non-Identifying | Zero or One to Zero or More | FK_SyCampus_SyQuickLeadTemplateID_SyQuickLeadTemplate_SyQuickLeadTemplateID |  |  | SyQuickLeadTemplateID | NO | YES
CmTemplate | Non-Identifying | Zero or One to Zero or More | FK_SyCampus_TransFaCmTemplateID_CmTemplate_CmTemplateID |  |  | TransFaCmTemplateID | NO | YES
SyStaff | Non-Identifying | Zero or One to Zero or More | FK_SyCampus_TransFaSyStaffID_SyStaff_SyStaffID |  |  | TransFaSyStaffID | NO | YES
CmTemplate | Non-Identifying | Zero or One to Zero or More | FK_SyCampus_TransSaCmTemplateID_CmTemplate_CmTemplateID |  |  | TransSaCmTemplateID | NO | YES
SyStaff | Non-Identifying | Zero or One to Zero or More | FK_SyCampus_TransSaSyStaffID_SyStaff_SyStaffID |  |  | TransSaSyStaffID | NO | YES
SyGroups | Non-Identifying | Zero or One to Zero or More | FK_SyCampus_TSMHoldGroupID_SyGroups_SyGroupsID |  |  | TSMHoldGroupID | NO | YES
SyGroups | Non-Identifying | Zero or One to Zero or More | FK_SyCampus_TsmStudentGroupID_SyGroups_SyGroupsID |  |  | TSMStudentGroupID | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication
CmEventHistory_ro | Non-Identifying | One To Zero or More | CmEventHistory_roSessionSyCampusID_SyCampusSyCampusID |  |  |  | NO | YES
FaSSCR | Non-Identifying | One To Zero or More | FaSSCR_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
AdAttendArchiveQueue | Non-Identifying | One To Zero or More | FK_AdAttendArchiveQueue_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
AdEnrollTermRelationshipException | Non-Identifying | One To Zero or More | FK_AdEnrollTermRelationshipException_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
AdGainfulEmploymentConfiguration | Non-Identifying | One To Zero or More | FK_AdGainfulEmploymentConfigurationSyCampusId_SyCampusSyCampusId |  |  |  | NO | YES
AdRegistrationGroupTerm | Non-Identifying | One To Zero or More | FK_AdRegistrationGroupTerm_SyCampusId_SyCampus_SyCampusId |  |  |  | NO | YES
AdSapQueue_Header | Non-Identifying | One To Zero or More | FK_AdSapQueue_Header_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
AdStartTerm | Non-Identifying | One To Zero or More | FK_AdStartTerm_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
AdStudentTransferHeader | Non-Identifying | One To Zero or More | FK_AdStudentTransferHeader_FromSyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
AdStudentTransferHeader | Non-Identifying | One To Zero or More | FK_AdStudentTransferHeader_ToSyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
AdTermCampusRelationship | Non-Identifying | One To Zero or More | FK_AdTermCampusRelationship_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | NO
AdTermOnLineRegistration | Identifying | One To Zero or More | FK_AdTermOnlineRegistration_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
adTermRelationshipModifyLog | Non-Identifying | One To Zero or More | FK_adTermRelationshipModifyLog_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
AmApplicant | Non-Identifying | One To Zero or More | FK_AmApplicant_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
AmCourseRelDetail | Non-Identifying | One To Zero or More | FK_AmCourseRelDetail.SyCampusID_SyCampus.SyCampusID |  |  |  | NO | YES
AmHighSchoolCourseRelationDetail | Non-Identifying | One To Zero or More | FK_AmHighSchoolCourseRelationDetailSyCampusID_SyCampusSyCampusID |  |  |  | NO | YES
AmTestImportCollegeCodeByCampus | Non-Identifying | One To Zero or More | FK_AmTestImportCollegeCodeByCampusSyCampusID_SyCampusSyCampusID |  |  |  | NO | YES
AmTestImportFileLayoutDetailAmTest | Non-Identifying | One To Zero or More | FK_AmTestImportFileLayoutDetailAmTestSyCampusID_SyCampusSyCampusID |  |  |  | NO | YES
CmDocLocation | Non-Identifying | One To Zero or More | FK_CmDocLocation_SyCampusId_SyCampus_SyCampusId |  |  |  | NO | YES
CmEvent | Non-Identifying | One To Zero or More | FK_CmEvent_SessionSyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
CmEventQueue | Non-Identifying | One To Zero or More | FK_CmEventQueue_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
CmGlobalDocumentCampus | Identifying | One To Zero or More | FK_CmGlobalDocumentCampus_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
cmIncident | Non-Identifying | One To Zero or More | FK_CMIncident_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
FaAwardLetterQueue | Non-Identifying | One To Zero or More | FK_FaAwardLetterQueue_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
FaAwardYearFundSourceDisable | Non-Identifying | One To Zero or More | FK_FaAwardYearFundSourceDisable_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
FaAwardYearMaxAmt | Non-Identifying | One To Zero or More | FK_FaAwardYearMaxAmt_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
FaBatchExpImp | Non-Identifying | One To Zero or More | FK_FaBatchExpImp.SyCampusID_SyCampus.SyCampusID |  |  |  | NO | YES
FaBatchPackage | Non-Identifying | One To Zero or More | FK_FaBatchPackage_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
FaCampusVantageWorkStudyPayroll | Non-Identifying | One To Zero or More | FK_FaCampusVantageWorkStudyPayroll_SyCampusID_SyCampus_SyCampusId |  |  |  | NO | YES
FaCashPlanConfigRelationship | Non-Identifying | One To Zero or More | FK_FaCashPlanConfigRelationshipSyCampusId_SyCampusSyCampusId |  |  |  | NO | YES
FaDisbCriteriaCampusFundSource | Identifying | One To Zero or More | FK_FaDisbCriteriaCampusFundSource_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
faExcusedAbsencePolicyDetail | Non-Identifying | One To Zero or More | FK_faExcusedAbsencePolicyDetail_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
FaFundSourceAutoAwardRules | Non-Identifying | One To Zero or More | FK_FaFundSourceAutoAwardRules_SyCampusId_SyCampus_SyCampusId |  |  |  | NO | YES
FaFundSourceBanks | Identifying | One To Zero or More | FK_FaFundSourceBanks_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
FaFundSourcePriority | Non-Identifying | One To Zero or More | FK_FaFundSourcePriority_SyCampus |  |  |  | NO | YES
FaGlAuthCampus | Non-Identifying | One To Zero or More | FK_FaGlAuthCampus_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
FaMultiDisbSchedCampusCriteria | Non-Identifying | One To Zero or More | FK_FaMultiDisbSchedCampusCriteriaSyCampusID_SyCampusSyCampusID |  |  |  | NO | YES
FaNoelLevitz | Non-Identifying | One To Zero or More | FK_FaNoelLevitzSyCampusId_SyCampusSyCampusId |  |  |  | NO | YES
FaProgramVersionCOA | Non-Identifying | One To Zero or More | FK_FaProgramVersionCOA_SyCampusId_SyCampus_SyCampusId |  |  |  | NO | YES
FaStudentAutoAwardLog | Non-Identifying | One To Zero or More | FK_FaStudentAutoAwardLog_SyCampusId_SyCampus_SyCampusId |  |  |  | NO | YES
FaStudentMaster | Non-Identifying | One To Zero or More | FK_FaStudentMaster_SyCampusId_SyCampus_SyCampusId |  |  |  | NO | YES
HsBuilding | Non-Identifying | One To Zero or More | FK_HsBuilding_syCampusID_syCampus_syCampusID |  |  |  | NO | YES
HSRoomMateMatch | Non-Identifying | One To Zero or More | FK_HsRoomMateMatch_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
HsStudentApplication | Non-Identifying | One To Zero or More | FK_HsStudentApplication_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
PlElectronicEmployer | Non-Identifying | One To Zero or More | FK_PlElectronicEmployer_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
SaACHConfigCampus | Non-Identifying | One To Zero or More | FK_SaACHConfigCampus_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
SaAttendancePostPermission | Non-Identifying | One To Zero or More | FK_SaAttendancePostPermission_SyCampusID_Sycampus_Sycampusid |  |  |  | NO | YES
SaAutoBillBatchDetail | Non-Identifying | One To Zero or More | FK_SaAutoBillBatchDetail_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
SaAutoCharge | Non-Identifying | One To Zero or More | FK_SaAutoCharge_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
SAAutoChargeProgramVersion | Non-Identifying | One To Zero or More | FK_SAAutoChargeProgramVersion_SyCampusId_SyCampus_SyCampusId |  |  |  | NO | YES
SaBillingStatementBatchStudent | Non-Identifying | One To Zero or More | FK_SaBillingStatementBatchStudent_SyCampusId_SyCampus_SyCampusID |  |  |  | NO | YES
SaCampusBillingResidencyTypeList | Non-Identifying | One To Zero or More | FK_SaCampusBillingResidencyTypeList_SyCampusId_SyCampus_SyCampusId |  |  |  | NO | NO
SaCampusVantageErrorLog | Non-Identifying | One To Zero or More | FK_SaCampusVantageErrorLog_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
SACreditCardCampus | Identifying | One To Zero or More | FK_SACreditCardCampus_SyCampus_SyCampus_SyCampusID |  |  |  | NO | YES
SaDynamicsErrorLog | Non-Identifying | One To Zero or More | FK_SaDynamicsErrorLog_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
SaEnrollRevenueChildTerm | Non-Identifying | One To Zero or More | FK_SaEnrollRevenueChildTerm_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
SaFundSourceOrder | Non-Identifying | One To Zero or More | FK_SaFundSourceOrder_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
SaMonthEndProcess | Non-Identifying | One To Zero or More | FK_SaMonthEndProces_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
SaPaymentApply | Non-Identifying | One To Zero or More | FK_SaPaymentApply_SyCampusId_SyCampus_SyCampusId |  |  |  | NO | YES
SaPaymentApplyOrder | Non-Identifying | One To Zero or More | FK_SaPaymentApplyOrder_SyCampusId_SyCampus_SyCampusId |  |  |  | NO | YES
SaPendingCharge | Non-Identifying | One To Zero or More | FK_saPendingCharge.SyCampusID_SyCampus.SyCampusID |  |  |  | NO | YES
SaPendingChargeCourseAmount | Non-Identifying | One To Zero or More | FK_SaPendingChargeCourseAmount_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
SaPendingChargeRecalcLog | Non-Identifying | One To Zero or More | FK_SaPendingChargeRecalcLog_SyCampusId_SyCampus_SyCampusID |  |  |  | NO | YES
SaPWDNotificationConfiguration | Non-Identifying | One To Zero or More | FK_SaPWDNotificationConfigurationSyCampusID_SyCampusSyCampusID |  |  |  | NO | YES
SaPWDRoutingTemplateRelationship | Non-Identifying | One To Zero or More | FK_SaPWDRoutingTemplateRelationshipSyCampusID_SyCampusSyCampusID |  |  |  | NO | YES
SaRefundCalculationAgeDaysConfiguration | Non-Identifying | One To Zero or More | FK_SaRefundCalculationAgeDaysConfigurationSyCampusId_SyCampusSyCampusId |  |  |  | NO | YES
SaRefundCalculationConfiguration | Non-Identifying | One To Zero or More | FK_SaRefundCalculationConfigurationSyCampusID_SyCampusSyCampusID |  |  |  | NO | YES
SaStudSubsidiaryTrans | Non-Identifying | One To Zero or More | Fk_SaStudSubsidiaryTrans_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
SaSubsidiaryCampus | Non-Identifying | One To Zero or More | FK_SaSubsidiaryCampus_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
SaTransCourseAmount | Non-Identifying | One To Zero or More | FK_SaTransCourseAmount_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
SaTuitionDiscountOrder | Non-Identifying | One To Zero or More | FK_SaTuitionDiscountOrderSyCampusID_SyCampusSyCampusID |  |  |  | NO | YES
SsLocation | Non-Identifying | One To Zero or More | FK_SsLocation_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
SyAdvancedSearchSavedCriteria | Non-Identifying | One To Zero or More | FK_SyAdvancedSearchSavedCriteria_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
SyAdvisorCampusDefaults | Identifying | One To Zero or More | FK_SyAdvisorCampusDefaults_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
SyAutomatedProcessActivation | Non-Identifying | One To Zero or More | FK_SyAutomatedProcessActivationSyCampusID_SyCampusSyCampusID |  |  |  | NO | YES
SyBatchRegulatory | Non-Identifying | One To Zero or More | FK_SyBatchRegulatorySyCampusId_SyCampus_SyCampusId |  |  |  | NO | YES
SyCampusADPaths | Non-Identifying | One To Zero or More | FK_SyCampusADPaths_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
SyCampusAutoAddCourseSection | Non-Identifying | One To Zero or More | FK_SyCampusAutoAddCourseSection_SyCampusId_SyCampus_SyCampusId |  |  |  | NO | YES
SyCampusAwardingConfig | Identifying | One To Zero or More | FK_SyCampusAwardingConfig_SyCampus |  |  |  | NO | YES
SyCampusCrossRegGroup | Non-Identifying | One To Zero or More | FK_SyCampusCrossRegGroup_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
SyCampusCrossRegGroup | Non-Identifying | One To Zero or More | FK_SyCampusCrossRegGroup_SyCampusShareID_SyCampus_SyCampusID |  |  |  | NO | YES
SyCampusDetails | Identifying | One To Zero or More | FK_SyCampusDetails_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
SyCampusECodes | Identifying | One To Zero or More | FK_SyCampusECodes_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
SyCampusEmails | Non-Identifying | One To Zero or More | FK_SyCampusEmails_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
syCampusExternalMap | Non-Identifying | One To Zero or More | FK_syCampusExternalMapsyCampusId_syCampussyCampusId |  |  |  | NO | YES
SyCampusLmsVendor | Non-Identifying | One To Zero or More | Fk_SyCampusLmsVendor_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
SyCampusTransferCreditStatus | Non-Identifying | One To Zero or More | FK_SyCampusTransferCreditStatus_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
SyCODDirectLoanEntity | Non-Identifying | One To Zero or More | FK_SyCODDirectLoanEntity_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
SyExceptionMessages | Non-Identifying | One To Zero or More | FK_SyExceptionMessages.SyCampusID_SyCampus.SyCampusID |  |  |  | NO | YES
syIMSConfiguration | Non-Identifying | One To Zero or More | FK_syIMSConfiguration_syCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
syIMSExtension | Non-Identifying | One To Zero or More | FK_syIMSExtension_syCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
syIMSExtensionStructure | Non-Identifying | One To Zero or More | FK_syIMSExtensionStructure_syCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
SyServiceException | Non-Identifying | One To Zero or More | FK_SyServiceException_SyCampus_SyCampusId |  |  |  | NO | YES
SyServiceExceptionCampusProperty | Non-Identifying | One To Zero or More | FK_SyServiceExceptionCampusProperty_SyCampusId_SyCampus_SyCampusId |  |  |  | NO | YES
SyServiceExceptionDocumentReview | Non-Identifying | One To Zero or More | FK_SyServiceExceptionDocumentReviewSyCampusID_SyCampusSyCampusID |  |  |  | NO | YES
SyServiceExceptionOverrideTemplateRelationship | Non-Identifying | One To Zero or More | FK_SyServiceExceptionOverrideTemplateRelationshipSyCampusId_SyCampusSyCampusId |  |  |  | NO | YES
SyServiceExceptionQueue | Non-Identifying | One To Zero or More | FK_SyServiceExceptionQueueSycampusID_SyCampusSyCampusID |  |  |  | NO | YES
SyServiceExceptionResolutionAutoGroupCampus | Non-Identifying | One To Zero or More | FK_SyServiceExceptionResolutionAutoGroupCampusSyCampusId_SyCampusId |  |  |  | NO | YES
SyServiceMessageSourceRecord | Non-Identifying | One To Zero or More | FK_SyServiceMessageSourceRecordSyCampusId_SyCampusSyCampusId |  |  |  | NO | YES
SyServiceProcessSubscriptionDetail | Non-Identifying | One To Zero or More | FK_SyServiceProcessSubscriptionDetailSyCampusId_SyCampusSyCampusId |  |  |  | NO | YES
SyServiceRecipientMailboxCommonLineRelationship | Non-Identifying | One To Zero or More | FK_SyServiceRecipientMailboxCommonLineRelationshipSyCampusId_SyCampusSyCampusId |  |  |  | NO | YES
SyServiceRecipientMailboxProcessRelationship | Non-Identifying | One To Zero or More | FK_SyServiceRecipientMailboxProcessRelationshipSyCampusId_SyCampusSyCampusId |  |  |  | NO | YES
SyServiceSTARExceptionQueue | Non-Identifying | One To Zero or More | FK_SyServiceSTARExceptionQueueSyCampusId_SyCampusSyCampusId |  |  |  | NO | YES
SyServiceSubscriptionExceptionRoutingRelationship | Non-Identifying | One To Zero or More | FK_SyServiceSubscriptionExceptionRoutingRelationshipSyCampusId_SyCampusSyCampusId |  |  |  | NO | YES
SySEVISCampus | Non-Identifying | One To Zero or More | FK_SySEVISCampus_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
SySEVISSiteOfActivity | Non-Identifying | One To Zero or More | FK_SySEVISSiteOfActivity_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
SyStateReportCampusInfo | Non-Identifying | One To Zero or More | FK_SyStateReportCampusInfo_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
SyStudentInquiry | Non-Identifying | One To Zero or More | FK_SyStudentInquiry_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
SyUserFormLog | Non-Identifying | One To Zero or More | FK_SyUserFormLog_DefaultSyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES
wpCampusSettings | Non-Identifying | One To Zero or More | Fk_wpCampusSettings_SyCampusID_SyCampus_SyCampusID |  |  |  | NO | YES

SyCampus Check Constraints

Check Constraint Name | CheckConstraint

SyCampus Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group | PRIMARY

SyCampus Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.Campus | NO |  |  |
Physical (Microsoft SQL Server) dbo.SyCampus | NO |  |  |

SyCampus Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | Applicant_Enroll
Logical | ElectronicPaymentProcessing
Logical | Employers
Logical | Grades/Attendance
Logical | Incidents
Logical | LedgerCard_Billing
Logical | PreviousEd_TransferCredits
Logical | Prospect
Logical | RefundCalculation
Logical | SEVIS
Logical | StudentEnrollment
Logical | SubsidiaryLedger
Logical | TestScores
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Academic Records
Physical (Microsoft SQL Server) | System

SyCampus Data Movement Rules

Name | Type | Rule Text/Value